package com.saas.sql;

public class AuthorityQuery
{
  public static String authority_INS_AUTHORITY_INFO_BY_ALL = "insert into authority(auth_id,menu_id,menu_name,menu_path,cust_id,user_id,oper_user,oper_time,role_name) values (:VAUTH_ID,:VMENU_ID,:VMENU_NAME,:VMENU_PATH,:VCUST_ID,:VUSER_ID,:VOPER_USER,now(),:VROLE_NAME)";
  public static String authority_DEL_AUTHORITY_INFO_BY_ALL = "delete from authority where menu_id = :VMENU_ID and role_name = :VROLE_NAME";
}

